SaTuitionDiscountPolicy

Logical Entity Name | SaTuitionDiscountPolicy
Default Table Name | SaTuitionDiscountPolicy
Physical Only | NO
Owner | dbo
Definition |
Note |

SaTuitionDiscountPolicy Columns

ColumnName | Domain | Datatype | NULL | Definition
SaTuitionDiscountPolicyID |  | int | NO |
Code |  | char(8) | YES |
Descrip |  | varchar(50) | YES |
CoursePercentageAmountFlag |  | char(1) | NO |
CourseDiscountPercentage |  | numeric(5, 2) | YES |
CourseDiscountAmount |  | money | YES |
TermPercentageAmountFlag |  | char(1) | NO |
TermDiscountPercentage |  | numeric(5, 2) | YES |
TermDiscountAmount |  | money | YES |
SaBillCodeID |  | int | NO |
Active |  | bit | NO |
SyCampusGrpID |  | int | YES |
CourseAttributeEqualsFlag |  | bit | NO |
CourseLevelEqualsFlag |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
AgeStartDate |  | char(1) | YES |
AgeSQL |  | varchar(50) | YES |
Automate |  | bit | NO |

SaTuitionDiscountPolicy Primary and Unique Keys

Key Name | Key Type | Keys
PK_SaTuitionDiscountPolicy_SaTuitionDiscountPolicyID_U_C_IDX | PrimaryKey | SaTuitionDiscountPolicyID

SaTuitionDiscountPolicy Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
SaBillCode | Non-Identifying | One To Zero or More | FK_SaTuitionDiscountPolicy_SaBillCodeID_SaBillCode_SaBillCodeID |  |  | SaBillCodeID | NO | YES
SyCampusGrp | Non-Identifying | Zero or One to Zero or More | FK_SaTuitionDiscountPolicy_SyCampusGrpID_SyCampusGrp_SyCampusGrpID |  |  | SyCampusGrpID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_SaTuitionDiscountPolicy_UserID_SyStaff_SyStaffID |  |  | UserID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
SaPendingCharge | Non-Identifying | One To Zero or More | FK_SaPendingCharge_SaTuitionDiscountPolicyID_SaTuitionDiscountPolicy_SaTuitionDiscountPolicyID |  |  |  | NO | YES
SaTuitionDiscountOrder | Non-Identifying | One To Zero or More | FK_SaTuitionDiscountOrderSaTuitionDiscountPolicyID_SaTuitionDiscountPolicySaTuitionDiscountPolicyID |  |  |  | NO | YES
SaTuitionDiscountPolicyCourseAttribute | Non-Identifying | One To Zero or More | FK_SaTuitionDiscountPolicyCourseAttribute_SaTuitionDiscountPolicyID_SaTuitionDiscountPolicy_SaTuitionDiscountPolicyID |  |  |  | NO | YES
SaTuitionDiscountPolicyCourseLevel | Non-Identifying | One To Zero or More | FK_SaTuitionDiscountPolicyCourseLevel_SaTuitionDiscountPolicyID_SaTuitionDiscountPolicy_SaTuitionDiscountPolicyID |  |  |  | NO | YES
SaTuitionDiscountPolicyStudentGroup | Non-Identifying | One To Zero or More | FK_SaTuitionDiscountPolicyStudentGroup_SaTuitionDiscountPolicyID_SaTuitionDiscountPolicy_SaTuitionDiscountPolicyID |  |  |  | NO | YES

SaTuitionDiscountPolicy Check Constraints

Check Constraint Name | CheckConstraint

SaTuitionDiscountPolicy Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SaTuitionDiscountPolicy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.TuitionDiscountPolicy | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaTuitionDiscountPolicy | NO |  |  |

SaTuitionDiscountPolicy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | LedgerCard_Billing
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Student Accounts

SaTuitionDiscountPolicy Data Movement Rules

Name | Type | Rule Text/Value